package util;

public class SQL {

    public static final String sql_empLogin =
            "select empno,empname,rolename,dutyname,emptype,idcard,sex,birth,tel from tb_emp as e " +
            "left join tb_role as r " +
            "on e.roleid=r.roleid " +
            "left join tb_duty as d " +
            "on e.dutyid=d.dutyid " +
            " where empname=? and password=?";

}
